﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace QLInternet.Model
{
    class Query
    {

        public String sql = "select KHACHHANG.MaKhachHang,HoTen,CMND,NgheNghiep,DiaChi,DienThoai,Email,DiaChiCaiDat,DiaChiHoaDon,SoLuongTaiKhoan,TenNguoiSuDung,DANGKY.TronGoi,TenKieuCaiDat,TenMoDem,TenGoiCuoc from KHACHHANG" +
            "  inner join DANGKY on KHACHHANG.MaKhachHang = DANGKY.MaKhachhang "+
            " inner join GOICUOC on DANGKY.MaGoiCuoc = GOICUOC.MaGoiCuoc "+
            " inner join CHITIETKIEUCAIDAT  on DANGKY.MaChiTietKieuCaiDat = CHITIETKIEUCAIDAT.MaChiTiet "+
            " inner join KIEUCAIDAT on KIEUCAIDAT.MaKieuCaiDat =  CHITIETKIEUCAIDAT.MaKieuCaiDat " +
            "inner join MODEM on CHITIETKIEUCAIDAT.MaMoDem = MODEM.MaMoDem";
        public String sqlGoiCuoc = "select MaGoiCuoc,TenGoiCuoc from GOICUOC ";
        public String sqlKieuCaiDat = "select MaKieuCaiDat, TenKieuCaiDat from KIEUCAIDAT";
        //public String sqlModem = "select MODEM.MaMoDem,TenMoDem from MODEM inner join CHITIETKIEUCAIDAT on MODEM.MaMoDem = CHITIETKIEUCAIDAT.MaMoDem where MaKieuCaiDat = ";
        public String sqlGetMaPhuongThuc = "select MaPhuongThuc from GOICUOC where MaGoiCuoc = ";

        public String sqlMaModem = "Select MaModem from CHITIETKIEUCAIDAT where MaKieuCaiDat =";
        public String sqlModem = "Select * from MODEM where MaModem =";

    }
}
